Changing the Database Configuration for Service Containers |
| This topic describes the procedure to change the database configuration for a service container. |
|
Before you begin this task:
- You must have the role of systemAdmin or organizationalAdmin to change the database configuration for a Service Container.
- You must be a Database Administrator to execute the DB Scripts.
If you have configured a database for a Service Container and wish to change it, you must execute certain DB scripts and import data from the old database to the new one. Execution of DB scripts may involve baseline scripts or service container specific scripts or both.
1. Execute the DB scripts. These scripts may vary depending on the Service Container.
Service Container Name |
Procedure to execute DB scripts |
Tag Server |
- Execute the baseline DB scripts of Process Platform Repository in the following way:
- Go to <Process_Platform_Installation_Directory>/Components/XDS/Database/CreateScripts. This location holds the script files.
- Depending on the database chosen during configuration, select the script and run it.
- Execute the INIT script.
- Execute the Tag Sever specific scripts in the following way:
- Go to <Process_Platform_Installation_Directory>/Components/TagServer/DBSchema/CreateScripts. This location holds the script files.
- Depending on the database chosen during configuration, select the script and run it.
|
- Task
- Security Administration
- XMLStore
|
If you intend to change the database configuration for Task, Security, and XMLStore Service Containers, below is the procedure:
- Go to <Process_Platform_Installation_Directory>/Components/XDS/Database/CreateScripts. This location holds the script files.
- Depending on the database chosen during configuration, select the script and run it.
- Execute the INIT script.
|
CoBOC |
- Go to <Process_Platform_Installation_Directory>/Components/CoBOC/Database/CreateScripts. This location holds the script files.
- Depending on the database chosen during configuration, select the script and run it.
- Execute the INIT script.
|
Scheduling |
- Go to <Process_Platform_Installation_Directory>/Components/Scheduler/Database/CreateScripts. This location holds the script files.
- Depending on the database chosen during configuration, select the script and run it.
|
Rule Management |
- Go to <Process_Platform_Installation_Directory>/Components/RuleManagement/Database/CreateScripts. This location holds the script files.
- Depending on the database chosen during configuration, select the script and run it.
|
The DB Scripts are executed.
2. Import the data from the old database to the newly configured database using the Import-Export tools provided by the databases. This allows you to reuse the content.
Note:
If you wish to create database content, run the INIT script to add the default content of the Service Container to the new database. Apart from this, you must use some porting tools to migrate the content related to Tasks and Tags.
3. On
CUSP >
My Applications, click
(
System Resource Manager). The
System Resource Manager window appears and lists the available Service Containers in the
Service Containers App Palette.
4. Select the Service Container, for which you intend to modify the database configuration and double-click it.
Note:
Alternatively, you can right-click a Service Container and select Properties option. Corresponding properties are displayed in the Properties - <Service Container Name> App Palette.
5. Select
<Service Container Name> tab in the
Properties - <Service Container Name> App Palette. The database configuration details are displayed.
6. Select a Database Configuration from the
Select Database Configuration drop-down menu. If the menu does not hold your database configuration, you must create it by selecting the
New Database Configuration option. For more information about creation, see
Creating a Database Configuration.
7. Click
and restart the Service Container for the changes to take effect.
The database configuration is changed for the Service Container.